<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.17"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>Aestate: aestate/opera/DBPool/simple_pooled_db.py Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">Aestate
   &#160;<span id="projectnumber">1.0.5</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.17 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="dir_374ee6e3281d8312d956f1f155302869.html">aestate</a></li><li class="navelem"><a class="el" href="dir_3d2a62c9f0038653f55551d1ba6b2e78.html">opera</a></li><li class="navelem"><a class="el" href="dir_222c18a5940c41eb83d2a46ecf15e75c.html">DBPool</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="headertitle">
<div class="title">simple_pooled_db.py</div>  </div>
</div><!--header-->
<div class="contents">
<a href="simple__pooled__db_8py.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"><a class="line" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db.html">    1</a></span>&#160;<span class="stringliteral">&quot;&quot;&quot;SimplePooledDB - a very simple DB-API 2 database connection pool.</span></div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="stringliteral">Implements a pool of threadsafe cached DB-API 2 connections</span></div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="stringliteral">to a database which are transparently reused.</span></div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="stringliteral">This should result in a speedup for persistent applications</span></div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="stringliteral">such as the &quot;Webware for Python&quot; AppServer.</span></div>
<div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="stringliteral">For more information on the DB-API 2, see:</span></div>
<div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="stringliteral">    https://www.python.org/dev/peps/pep-0249/</span></div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="stringliteral">For more information on Webware for Python, see:</span></div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="stringliteral">    https://webwareforpython.github.io/w4py/</span></div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="stringliteral">Measures are taken to make the pool of connections threadsafe</span></div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="stringliteral">regardless of whether the DB-API 2 module used is threadsafe</span></div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="stringliteral">on the connection level (threadsafety &gt; 1) or not.  It must only</span></div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="stringliteral">be threadsafe on the module level (threadsafety = 1).  If the</span></div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="stringliteral">DB-API 2 module is threadsafe, the connections will be shared</span></div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="stringliteral">between threads (keep this in mind if you use transactions).</span></div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="stringliteral">Usage:</span></div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="stringliteral">The idea behind SimplePooledDB is that it&#39;s completely transparent.</span></div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="stringliteral">After you have established your connection pool, stating the</span></div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="stringliteral">DB-API 2 module to be used, the number of connections</span></div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="stringliteral">to be cached in the pool and the connection parameters, e.g.</span></div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;<span class="stringliteral">    import pgdb  # import used DB-API 2 module</span></div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="stringliteral">    from dbutils.simple_pooled_db import PooledDB</span></div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;<span class="stringliteral">    dbpool = PooledDB(pgdb, 5, host=..., database=..., user=..., ...)</span></div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;<span class="stringliteral">you can demand database connections from that pool,</span></div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;<span class="stringliteral">    db = dbpool.connection()</span></div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;<span class="stringliteral">and use them just as if they were ordinary DB-API 2 connections.</span></div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;<span class="stringliteral">It&#39;s really just a proxy class.</span></div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;<span class="stringliteral">db.close() will return the connection to the pool, it will not</span></div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;<span class="stringliteral">actually close it.  This is so your existing code works nicely.</span></div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;<span class="stringliteral">Ideas for improvement:</span></div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;<span class="stringliteral">* Do not create the maximum number of connections on startup</span></div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;<span class="stringliteral">already, but only a certain number and the rest on demand.</span></div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;<span class="stringliteral">* Detect and transparently reset &quot;bad&quot; connections.</span></div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;<span class="stringliteral">* Connections should have some sort of maximum usage limit</span></div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;<span class="stringliteral">after which they should be automatically closed and reopened.</span></div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;<span class="stringliteral">* Prefer or enforce thread-affinity for the connections,</span></div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;<span class="stringliteral">allowing for both shareable and non-shareable connections.</span></div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;<span class="stringliteral">Please note that these and other ideas have been already</span></div>
<div class="line"><a name="l00053"></a><span class="lineno">   53</span>&#160;<span class="stringliteral">implemented in in PooledDB, a more sophisticated version</span></div>
<div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;<span class="stringliteral">of SimplePooledDB.  You might also consider using PersistentDB</span></div>
<div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;<span class="stringliteral">instead for thread-affine persistent database connections.</span></div>
<div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;<span class="stringliteral">SimplePooledDB may still serve as a very simple reference</span></div>
<div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;<span class="stringliteral">and example implementation for developers.</span></div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;<span class="stringliteral">Copyright, credits and license:</span></div>
<div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;<span class="stringliteral">* Contributed as MiscUtils/DBPool for Webware for Python</span></div>
<div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;<span class="stringliteral">  by Dan Green, December 2000</span></div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;<span class="stringliteral">* Thread safety bug found by Tom Schwaller</span></div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;<span class="stringliteral">* Fixes by Geoff Talvola (thread safety in _threadsafe_getConnection())</span></div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;<span class="stringliteral">* Clean up by Chuck Esterbrook</span></div>
<div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;<span class="stringliteral">* Fix unthreadsafe functions which were leaking, Jay Love</span></div>
<div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;<span class="stringliteral">* Eli Green&#39;s webware-discuss comments were lifted for additional docs</span></div>
<div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;<span class="stringliteral">* Clean-up and detailed commenting, rename and move to DBUtils</span></div>
<div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;<span class="stringliteral">  by Christoph Zwerschke in September 2005</span></div>
<div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;<span class="stringliteral">Licensed under the MIT license.</span></div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;<span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160; </div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;<span class="keyword">from</span> . <span class="keyword">import</span> __version__</div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160; </div>
<div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160; </div>
<div class="line"><a name="l00078"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_error.html">   78</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_error.html">PooledDBError</a>(Exception):</div>
<div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;General PooledDB error.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160; </div>
<div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160; </div>
<div class="line"><a name="l00082"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_not_supported_error.html">   82</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_not_supported_error.html">NotSupportedError</a>(<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_error.html">PooledDBError</a>):</div>
<div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;DB-API module not supported by PooledDB.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160; </div>
<div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160; </div>
<div class="line"><a name="l00086"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html">   86</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html">PooledDBConnection</a>:</div>
<div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;A proxy class for pooled database connections.</span></div>
<div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;<span class="stringliteral">    You don&#39;t normally deal with this class directly,</span></div>
<div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;<span class="stringliteral">    but use PooledDB to get new connections.</span></div>
<div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;<span class="stringliteral">    &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160; </div>
<div class="line"><a name="l00093"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a366f72b79a2e0c38519d2185dccf9900">   93</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a366f72b79a2e0c38519d2185dccf9900">__init__</a>(self, pool, con):</div>
<div class="line"><a name="l00094"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a7cd9cc13891f5e7c821183f28c07fa19">   94</a></span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a7cd9cc13891f5e7c821183f28c07fa19">_con</a> = con</div>
<div class="line"><a name="l00095"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a1df2d901ecd75b00ba3e615d3f4f4956">   95</a></span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a1df2d901ecd75b00ba3e615d3f4f4956">_pool</a> = pool</div>
<div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160; </div>
<div class="line"><a name="l00097"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a40227bb4bb89e7cafdc8460f27b58551">   97</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a40227bb4bb89e7cafdc8460f27b58551">close</a>(self):</div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Close the pooled connection.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;        <span class="comment"># Instead of actually closing the connection,</span></div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;        <span class="comment"># return it to the pool so it can be reused.</span></div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;        <span class="keywordflow">if</span> self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a7cd9cc13891f5e7c821183f28c07fa19">_con</a> <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a1df2d901ecd75b00ba3e615d3f4f4956">_pool</a>.returnConnection(self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a7cd9cc13891f5e7c821183f28c07fa19">_con</a>)</div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a7cd9cc13891f5e7c821183f28c07fa19">_con</a> = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160; </div>
<div class="line"><a name="l00105"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a930b81c541e966a2aafc65560bfa8bd9">  105</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a930b81c541e966a2aafc65560bfa8bd9">__getattr__</a>(self, name):</div>
<div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;        <span class="comment"># All other members are the same.</span></div>
<div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;        <span class="keywordflow">return</span> getattr(self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a7cd9cc13891f5e7c821183f28c07fa19">_con</a>, name)</div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160; </div>
<div class="line"><a name="l00109"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a369e0b5db2f5b77e5b5b7917c3f21a84">  109</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a369e0b5db2f5b77e5b5b7917c3f21a84">__del__</a>(self):</div>
<div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a40227bb4bb89e7cafdc8460f27b58551">close</a>()</div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160; </div>
<div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160; </div>
<div class="line"><a name="l00113"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html">  113</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html">PooledDB</a>:</div>
<div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;A very simple database connection pool.</span></div>
<div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;<span class="stringliteral">    After you have created the connection pool,</span></div>
<div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;<span class="stringliteral">    you can get connections using getConnection().</span></div>
<div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;<span class="stringliteral">    &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160; </div>
<div class="line"><a name="l00120"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a92104daab76603d66d535be4f3464b99">  120</a></span>&#160;    version = __version__</div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160; </div>
<div class="line"><a name="l00122"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a7607dc0d9ea8f01c19afd62e5008fa17">  122</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a7607dc0d9ea8f01c19afd62e5008fa17">__init__</a>(self, dbapi, maxconnections, *args, **kwargs):</div>
<div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Set up the database connection pool.</span></div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;<span class="stringliteral">        dbapi: the DB-API 2 compliant module you want to use</span></div>
<div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;<span class="stringliteral">        maxconnections: the number of connections cached in the pool</span></div>
<div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;<span class="stringliteral">        args, kwargs: the parameters that shall be used to establish</span></div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;<span class="stringliteral">            the database connections using connect()</span></div>
<div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;            threadsafety = dbapi.threadsafety</div>
<div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;        <span class="keywordflow">except</span> Exception:</div>
<div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;            threadsafety = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;        <span class="keywordflow">if</span> threadsafety == 0:</div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;            <span class="keywordflow">raise</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_not_supported_error.html">NotSupportedError</a>(</div>
<div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;                <span class="stringliteral">&quot;Database module does not support any level of threading.&quot;</span>)</div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;        <span class="keywordflow">elif</span> threadsafety == 1:</div>
<div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;            <span class="comment"># If there is no connection level safety, build</span></div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;            <span class="comment"># the pool using the synchronized queue class</span></div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;            <span class="comment"># that implements all the required locking semantics.</span></div>
<div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;            <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;                <span class="keyword">from</span> Queue <span class="keyword">import</span> Queue</div>
<div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;            <span class="keywordflow">except</span> ImportError:  <span class="comment"># Python 3</span></div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;                <span class="keyword">from</span> queue <span class="keyword">import</span> Queue</div>
<div class="line"><a name="l00145"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6fddcedf805b0db09bff8d84b91c167b">  145</a></span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6fddcedf805b0db09bff8d84b91c167b">_queue</a> = Queue(maxconnections)  <span class="comment"># create the queue</span></div>
<div class="line"><a name="l00146"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a1161dd603c81adc144415bd504a3a4ad">  146</a></span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a1161dd603c81adc144415bd504a3a4ad">connection</a> = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a57a454fe983281c8602847c06338e0c1">_unthreadsafe_get_connection</a></div>
<div class="line"><a name="l00147"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0aa7a2d846a2c689d848ae1262ffd4a2">  147</a></span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0aa7a2d846a2c689d848ae1262ffd4a2">addConnection</a> = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a84cff5f9924b80b2119c225577fe8ea8">_unthreadsafe_add_connection</a></div>
<div class="line"><a name="l00148"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2fd7dc22a7e457dc99a07246f242c3f6">  148</a></span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2fd7dc22a7e457dc99a07246f242c3f6">returnConnection</a> = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2424208099517a9260d3365981ffd497">_unthreadsafe_return_connection</a></div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;        <span class="keywordflow">elif</span> threadsafety <span class="keywordflow">in</span> (2, 3):</div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;            <span class="comment"># If there is connection level safety, implement the</span></div>
<div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;            <span class="comment"># pool with an ordinary list used as a circular buffer.</span></div>
<div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;            <span class="comment"># We only need a minimum of locking in this case.</span></div>
<div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;            <span class="keyword">from</span> threading <span class="keyword">import</span> Lock</div>
<div class="line"><a name="l00154"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0409e33fd7edab1d103622cd5e1d8a92">  154</a></span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0409e33fd7edab1d103622cd5e1d8a92">_lock</a> = Lock()  <span class="comment"># create a lock object to be used later</span></div>
<div class="line"><a name="l00155"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a4874fc464467e0a2e91f5d174100b147">  155</a></span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a4874fc464467e0a2e91f5d174100b147">_nextConnection</a> = 0  <span class="comment"># index of the next connection to be used</span></div>
<div class="line"><a name="l00156"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6a2e9c0626453656973c65084f740511">  156</a></span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6a2e9c0626453656973c65084f740511">_connections</a> = []  <span class="comment"># the list of connections</span></div>
<div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a1161dd603c81adc144415bd504a3a4ad">connection</a> = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2793ef8ae059da4179c44d72d77ea34a">_threadsafe_get_connection</a></div>
<div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0aa7a2d846a2c689d848ae1262ffd4a2">addConnection</a> = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6ae55cf0d7e45b8e85b0ede0b818be40">_threadsafe_add_connection</a></div>
<div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2fd7dc22a7e457dc99a07246f242c3f6">returnConnection</a> = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a9a2fd47d51862fec46caed94fdc76993">_threadsafe_return_connection</a></div>
<div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;            <span class="keywordflow">raise</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_not_supported_error.html">NotSupportedError</a>(</div>
<div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160;                <span class="stringliteral">&quot;Database module threading support cannot be determined.&quot;</span>)</div>
<div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;        <span class="comment"># Establish all database connections (it would be better to</span></div>
<div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;        <span class="comment"># only establish a part of them now, and the rest on demand).</span></div>
<div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;        <span class="keywordflow">for</span> i <span class="keywordflow">in</span> range(maxconnections):</div>
<div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0aa7a2d846a2c689d848ae1262ffd4a2">addConnection</a>(dbapi.connect(*args, **kwargs))</div>
<div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160; </div>
<div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160;    <span class="comment"># The following functions are used with DB-API 2 modules</span></div>
<div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;    <span class="comment"># that do not have connection level threadsafety, like PyGreSQL.</span></div>
<div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;    <span class="comment"># However, the module must be threadsafe at the module level.</span></div>
<div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;    <span class="comment"># Note: threadsafe/unthreadsafe refers to the DB-API 2 module,</span></div>
<div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;    <span class="comment"># not to this class which should be threadsafe in any case.</span></div>
<div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160; </div>
<div class="line"><a name="l00174"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a57a454fe983281c8602847c06338e0c1">  174</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a57a454fe983281c8602847c06338e0c1">_unthreadsafe_get_connection</a>(self):</div>
<div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Get a connection from the pool.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;        <span class="keywordflow">return</span> <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html">PooledDBConnection</a>(self, self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6fddcedf805b0db09bff8d84b91c167b">_queue</a>.get())</div>
<div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160; </div>
<div class="line"><a name="l00178"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a84cff5f9924b80b2119c225577fe8ea8">  178</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a84cff5f9924b80b2119c225577fe8ea8">_unthreadsafe_add_connection</a>(self, con):</div>
<div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Add a connection to the pool.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00180"></a><span class="lineno">  180</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6fddcedf805b0db09bff8d84b91c167b">_queue</a>.put(con)</div>
<div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160; </div>
<div class="line"><a name="l00182"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2424208099517a9260d3365981ffd497">  182</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2424208099517a9260d3365981ffd497">_unthreadsafe_return_connection</a>(self, con):</div>
<div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Return a connection to the pool.</span></div>
<div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;<span class="stringliteral">        In this case, the connections need to be put</span></div>
<div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;<span class="stringliteral">        back into the queue after they have been used.</span></div>
<div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;<span class="stringliteral">        This is done automatically when the connection is closed</span></div>
<div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;<span class="stringliteral">        and should never be called explicitly outside of this module.</span></div>
<div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a84cff5f9924b80b2119c225577fe8ea8">_unthreadsafe_add_connection</a>(con)</div>
<div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160; </div>
<div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;    <span class="comment"># The following functions are used with DB-API 2 modules</span></div>
<div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;    <span class="comment"># that are threadsafe at the connection level, like psycopg.</span></div>
<div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160;    <span class="comment"># Note: In this case, connections are shared between threads.</span></div>
<div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;    <span class="comment"># This may lead to problems if you use transactions.</span></div>
<div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160; </div>
<div class="line"><a name="l00197"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2793ef8ae059da4179c44d72d77ea34a">  197</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2793ef8ae059da4179c44d72d77ea34a">_threadsafe_get_connection</a>(self):</div>
<div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Get a connection from the pool.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0409e33fd7edab1d103622cd5e1d8a92">_lock</a>.acquire()</div>
<div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;            next = self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a4874fc464467e0a2e91f5d174100b147">_nextConnection</a></div>
<div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160;            con = <a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html">PooledDBConnection</a>(self, self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6a2e9c0626453656973c65084f740511">_connections</a>[next])</div>
<div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160;            next += 1</div>
<div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;            <span class="keywordflow">if</span> next &gt;= len(self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6a2e9c0626453656973c65084f740511">_connections</a>):</div>
<div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;                next = 0</div>
<div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a4874fc464467e0a2e91f5d174100b147">_nextConnection</a> = next</div>
<div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;            <span class="keywordflow">return</span> con</div>
<div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;        <span class="keywordflow">finally</span>:</div>
<div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;            self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0409e33fd7edab1d103622cd5e1d8a92">_lock</a>.release()</div>
<div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160; </div>
<div class="line"><a name="l00211"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6ae55cf0d7e45b8e85b0ede0b818be40">  211</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6ae55cf0d7e45b8e85b0ede0b818be40">_threadsafe_add_connection</a>(self, con):</div>
<div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Add a connection to the pool.&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;        self.<a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6a2e9c0626453656973c65084f740511">_connections</a>.append(con)</div>
<div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160; </div>
<div class="line"><a name="l00215"></a><span class="lineno"><a class="line" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a9a2fd47d51862fec46caed94fdc76993">  215</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a9a2fd47d51862fec46caed94fdc76993">_threadsafe_return_connection</a>(self, con):</div>
<div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;Return a connection to the pool.</span></div>
<div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;<span class="stringliteral">        In this case, the connections always stay in the pool,</span></div>
<div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;<span class="stringliteral">        so there is no need to do anything here.</span></div>
<div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;        <span class="keywordflow">pass</span></div>
</div><!-- fragment --></div><!-- contents -->
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a57a454fe983281c8602847c06338e0c1"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a57a454fe983281c8602847c06338e0c1">aestate.opera.DBPool.simple_pooled_db.PooledDB._unthreadsafe_get_connection</a></div><div class="ttdeci">def _unthreadsafe_get_connection(self)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00174">simple_pooled_db.py:174</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a2fd7dc22a7e457dc99a07246f242c3f6"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2fd7dc22a7e457dc99a07246f242c3f6">aestate.opera.DBPool.simple_pooled_db.PooledDB.returnConnection</a></div><div class="ttdeci">returnConnection</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00148">simple_pooled_db.py:148</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection_html_a40227bb4bb89e7cafdc8460f27b58551"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a40227bb4bb89e7cafdc8460f27b58551">aestate.opera.DBPool.simple_pooled_db.PooledDBConnection.close</a></div><div class="ttdeci">def close(self)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00097">simple_pooled_db.py:97</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a0409e33fd7edab1d103622cd5e1d8a92"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0409e33fd7edab1d103622cd5e1d8a92">aestate.opera.DBPool.simple_pooled_db.PooledDB._lock</a></div><div class="ttdeci">_lock</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00154">simple_pooled_db.py:154</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection_html_a930b81c541e966a2aafc65560bfa8bd9"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a930b81c541e966a2aafc65560bfa8bd9">aestate.opera.DBPool.simple_pooled_db.PooledDBConnection.__getattr__</a></div><div class="ttdeci">def __getattr__(self, name)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00105">simple_pooled_db.py:105</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a6a2e9c0626453656973c65084f740511"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6a2e9c0626453656973c65084f740511">aestate.opera.DBPool.simple_pooled_db.PooledDB._connections</a></div><div class="ttdeci">_connections</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00156">simple_pooled_db.py:156</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection_html_a369e0b5db2f5b77e5b5b7917c3f21a84"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a369e0b5db2f5b77e5b5b7917c3f21a84">aestate.opera.DBPool.simple_pooled_db.PooledDBConnection.__del__</a></div><div class="ttdeci">def __del__(self)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00109">simple_pooled_db.py:109</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a6fddcedf805b0db09bff8d84b91c167b"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6fddcedf805b0db09bff8d84b91c167b">aestate.opera.DBPool.simple_pooled_db.PooledDB._queue</a></div><div class="ttdeci">_queue</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00145">simple_pooled_db.py:145</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection_html_a366f72b79a2e0c38519d2185dccf9900"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a366f72b79a2e0c38519d2185dccf9900">aestate.opera.DBPool.simple_pooled_db.PooledDBConnection.__init__</a></div><div class="ttdeci">def __init__(self, pool, con)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00093">simple_pooled_db.py:93</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection_html_a1df2d901ecd75b00ba3e615d3f4f4956"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a1df2d901ecd75b00ba3e615d3f4f4956">aestate.opera.DBPool.simple_pooled_db.PooledDBConnection._pool</a></div><div class="ttdeci">_pool</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00095">simple_pooled_db.py:95</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html">aestate.opera.DBPool.simple_pooled_db.PooledDB</a></div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00113">simple_pooled_db.py:113</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a9a2fd47d51862fec46caed94fdc76993"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a9a2fd47d51862fec46caed94fdc76993">aestate.opera.DBPool.simple_pooled_db.PooledDB._threadsafe_return_connection</a></div><div class="ttdeci">def _threadsafe_return_connection(self, con)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00215">simple_pooled_db.py:215</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a1161dd603c81adc144415bd504a3a4ad"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a1161dd603c81adc144415bd504a3a4ad">aestate.opera.DBPool.simple_pooled_db.PooledDB.connection</a></div><div class="ttdeci">connection</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00146">simple_pooled_db.py:146</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a2793ef8ae059da4179c44d72d77ea34a"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2793ef8ae059da4179c44d72d77ea34a">aestate.opera.DBPool.simple_pooled_db.PooledDB._threadsafe_get_connection</a></div><div class="ttdeci">def _threadsafe_get_connection(self)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00197">simple_pooled_db.py:197</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a2424208099517a9260d3365981ffd497"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a2424208099517a9260d3365981ffd497">aestate.opera.DBPool.simple_pooled_db.PooledDB._unthreadsafe_return_connection</a></div><div class="ttdeci">def _unthreadsafe_return_connection(self, con)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00182">simple_pooled_db.py:182</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a0aa7a2d846a2c689d848ae1262ffd4a2"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a0aa7a2d846a2c689d848ae1262ffd4a2">aestate.opera.DBPool.simple_pooled_db.PooledDB.addConnection</a></div><div class="ttdeci">addConnection</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00147">simple_pooled_db.py:147</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection_html"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html">aestate.opera.DBPool.simple_pooled_db.PooledDBConnection</a></div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00086">simple_pooled_db.py:86</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a84cff5f9924b80b2119c225577fe8ea8"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a84cff5f9924b80b2119c225577fe8ea8">aestate.opera.DBPool.simple_pooled_db.PooledDB._unthreadsafe_add_connection</a></div><div class="ttdeci">def _unthreadsafe_add_connection(self, con)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00178">simple_pooled_db.py:178</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a6ae55cf0d7e45b8e85b0ede0b818be40"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a6ae55cf0d7e45b8e85b0ede0b818be40">aestate.opera.DBPool.simple_pooled_db.PooledDB._threadsafe_add_connection</a></div><div class="ttdeci">def _threadsafe_add_connection(self, con)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00211">simple_pooled_db.py:211</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection_html_a7cd9cc13891f5e7c821183f28c07fa19"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_connection.html#a7cd9cc13891f5e7c821183f28c07fa19">aestate.opera.DBPool.simple_pooled_db.PooledDBConnection._con</a></div><div class="ttdeci">_con</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00094">simple_pooled_db.py:94</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_error_html"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_error.html">aestate.opera.DBPool.simple_pooled_db.PooledDBError</a></div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00078">simple_pooled_db.py:78</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a4874fc464467e0a2e91f5d174100b147"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a4874fc464467e0a2e91f5d174100b147">aestate.opera.DBPool.simple_pooled_db.PooledDB._nextConnection</a></div><div class="ttdeci">_nextConnection</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00155">simple_pooled_db.py:155</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_not_supported_error_html"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_not_supported_error.html">aestate.opera.DBPool.simple_pooled_db.NotSupportedError</a></div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00082">simple_pooled_db.py:82</a></div></div>
<div class="ttc" id="aclassaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b_html_a7607dc0d9ea8f01c19afd62e5008fa17"><div class="ttname"><a href="classaestate_1_1opera_1_1_d_b_pool_1_1simple__pooled__db_1_1_pooled_d_b.html#a7607dc0d9ea8f01c19afd62e5008fa17">aestate.opera.DBPool.simple_pooled_db.PooledDB.__init__</a></div><div class="ttdeci">def __init__(self, dbapi, maxconnections, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="simple__pooled__db_8py_source.html#l00122">simple_pooled_db.py:122</a></div></div>
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.17
</small></address>
</body>
</html>
